Business
http://catalog.sierracollege.edu/departments/business/
The business discipline offers training in nine major areas: Accounting, Administrative Professional, Business Administration, Business Entrepreneurship, General Business, Management, Marketing and Real Estate. For Information Technology (formerly known as Computer Information Systems) and Computer Science, see separate catalog listings. The Business department plays a vital role in preparing students for their careers. Experience has demonstrated the importance of a background in general education for all students planning a career in business.
IT 0055 - Database Management
http://catalog.sierracollege.edu/course-outlines/it-0055/
Catalog Description DESCRIPTION IS HERE: Formerly known as CIS 90 Advisory: Completion of Bus 252 with grade of "C" or better or strong understanding of MS Office Application navigation Hours: 72 (54 lecture, 18 laboratory) Description: Discover the intricacies of relational databases using the current version of Microsoft Access. Includes designing database structures: tables, queries, forms, reports, and macros. Also includes integrating with the Web, Excel and other programs. Emphasis on hands-on learning. (C-ID ITIS 180) (CSU) Units 3 Lecture-Discussion 54 Laboratory 18 By Arrangement Contact Hours 72 Outside of Class Hours Course Student Learning Outcomes Research, analyze and evaluate information to solve business problems using a database management application. Design and produce database management solutions incorporating current trends, security, and best practices. Employ database management concepts and terminology in professional communication. Demonstrate marketable database management career skills. Course Content Outline I. Introduction to database structure A. Database structures and how they work B. Field and field types C. Record lengths D. Accessing files E. Searching files F. Changing/updating files II. Database design A. Problem solving B. Determine what is to be included and how to be stored C. Designing data entry screens D. Calculations E. Establishing relationships tables and queries III. Database use and report and label generation A. Methods of accessing data B. Designing output report C. Producing output IV. Enhancing basic database functions A. Macros and Modules B. Data Access Pages C. Switchboards V. Optimizing the Database A. Compacting a database B. Documenting the database C. Securing the database Course Objectives Course Objectives Lecture Objectives: 1. Identify and explain database structures and types; 2. Explain how to extend Access databases using VBA; 3. Discuss how to Integrate data stores with Web and other programs; and 4. Describe how to Secure database files. 5. Discuss the importance of Referential Integrity in a relational database 6. Identify when to use Forms for data entry and why it helps with error control. 7. Explain what SQL is and why it is important to understand it’s use. 8. Define the compatibility of Access and Excel 9. Explain the difference between a Primary Key and a Foreign Key 10. Define when you would use the Cascade Updates feature 11. Discuss how Inner Join and Outer Join can be used to impact the outcome of a query Laboratory Objectives: 1. Design and use databases; 2. Establish database tables and input/modify data; 3. Establish relationships between tables using common fields. 4. Create custom forms that interact with tables; 5. Generate queries for data extraction; 5. Produce finalized reports from data queries. 7. Utilize database functions, such as filing, retrieving, updating, sorting, searching, and calculating; 8. Design forms for input and custom access; 9. Design and produce database reports; and 10. Extend Access databases using VBA Methods of Evaluation Objective Examinations Problem Solving Examinations Projects Skill Demonstrations Reading Assignments Students will read one chapter from the textbook each week prior to the class meeting to familiarize themselves with terminology and concepts. 1. Example: Read the chapter titled "Introduction to Microsoft Access" - working with an existing database, and be prepared to discuss in class. 2. Example: Read the chapter titled "Creating Custom Forms", and be prepared to discuss in class. Writing, Problem Solving or Performance 1. Students will complete a set of chapter review questions for each chapter. Example: True or False - A bond form is a form that has a table or query as its record source. You use a bond form for maintaining and displaying table data. 2. Students will complete hands-on lab computer assignments applying the weekly concepts. Example: Open the week 1 database, add the following record to the student table XXXXX. Open the student success report and print a copy. Other (Term projects, research papers, portfolios, etc.) Students will design a simple database of their choice that will include tables, queries, forms, reports and if needed macros. This will be a 3 part project. Part 1 - submit and ERD, Part 2 - rough draft and Part 3 final database. Methods of Instruction Laboratory Lecture/Discussion Distance Learning Other materials and-or supplies required of students that contribute to the cost of the course. Students should bring a 10 GB or larger USB drive for moving files from home to school and back unless they have high-speed internet access off-site for transferring files directly.
Course Identification Numbering System (C-ID)
...0001 BUS 110 BUS 0260 BUS 115 BUS...0050 AJ 120 ADMJ 0055 AJ 122 ADMJ...
Information Technology
http://catalog.sierracollege.edu/departments/infotech/
...BUS 0252 Excel for Business Applications 3 IT 0015 Business Information Systems 3 IT 0055...
